Creating Bullet Charts and Tree Maps in Tableau – Complete Detailed Notes

Topic: Tableau Data Visualization and Business Intelligence

Learning Objectives: Understand bullet charts and treemaps, learn their purposes and components, create both visualizations step by step, customize their appearance, interpret results, and use them in practical business dashboards.

Tableau Training: JustAcademy Tableau Training

Course Demo: Register for a Tableau Course Demo

Official Tableau Guides: Creating Bullet Charts | Creating Treemaps

1. Introduction

Tableau provides several visualization types to help users understand business data. Bullet charts and treemaps are two useful visualizations, but they answer different questions.

A bullet chart compares an actual or primary measure against a target, benchmark, or another measure. It is useful for evaluating performance, such as actual sales versus sales targets.

A treemap displays hierarchical or categorical data using rectangles. The size of each rectangle represents a quantitative value, while its color can represent another measure or a category. It is useful for analyzing contributions to a total.

2. Creating Bullet Charts in Tableau

2.1 What Is a Bullet Chart?

A bullet chart is a compact performance visualization that compares a primary measure with a target or another reference measure. It can also include shaded performance ranges that indicate levels such as poor, satisfactory, and good.

Bullet charts are often used instead of dashboard gauges because they can present performance information in a compact format and make comparisons across multiple categories easier.

2.2 Main Components of a Bullet Chart

• Primary bar: Represents the main measure, such as actual sales or actual expenditure.
• Target marker: Represents a goal, target, or reference value.
• Reference line: Shows a comparison value, such as a target or average.
• Performance bands: Shaded background ranges provide context for interpreting the primary measure.
• Category dimension: Identifies what is being compared, such as a region, product, or employee.
• Axis: Shows the numerical scale used to compare actual and target values.

2.3 When Should You Use a Bullet Chart?

• Compare actual sales with sales targets.
• Compare actual expenses with budgeted expenses.
• Evaluate employee performance against quotas.
• Monitor production output against planned output.
• Compare service performance with a defined benchmark.
• Track the performance of multiple departments or regions.

2.4 Example of a Bullet Chart

A bullet chart can represent Actual Sales as a bar and Target Sales as a reference marker. This helps a manager quickly see which regions are meeting or exceeding their targets.

3. Step-by-Step: Create a Bullet Chart

Step 1: Open Tableau

1. Launch Tableau Desktop or Tableau Public.
2. Connect to a dataset containing a dimension and two measures.
3. For practice, use Tableau's Sample - Superstore dataset or a dataset containing actual and target sales.
4. Open a new worksheet.

Step 2: Identify the Required Fields

A bullet chart generally needs a category dimension and two measures that can be compared. For example:

• Dimension: Region
• Primary measure: Actual Sales
• Comparison measure: Target Sales

If the dataset does not contain a target measure, you may need to obtain target data or create an appropriate calculated field. Do not treat an arbitrary value as a genuine business target.

Step 3: Select the Required Fields

In the Data pane, select the dimension and the two measures needed for the comparison. In Tableau Desktop, you can usually select multiple fields using Ctrl on Windows or the corresponding modifier key on macOS.

Step 4: Open Show Me

Click Show Me on the toolbar and select Bullet Graph if the required fields are supported by the selected chart type.

Tableau creates a bullet chart using the selected measures. Depending on the fields and default settings, one measure is displayed as the primary bar and the other is used for the reference comparison or distribution.

Step 5: Add the Category Dimension

Drag Region, Department, Product, or another relevant dimension to Rows so that Tableau creates a separate bullet chart for each category.

Step 6: Review the Primary Measure

Check that the main bar represents the measure you want to evaluate, such as Actual Sales. If the wrong measure appears as the primary bar, review the fields on the shelves and the reference-line settings.

Step 7: Configure the Target or Reference Measure

Review the comparison measure and reference marker. Depending on the generated view, you may be able to right-click the axis and select an option such as Swap Reference Line Fields to change which measure is used for the bar and which is used for the reference distribution.

Step 8: Edit Performance Bands

Bullet charts can include shaded reference distribution bands. Right-click a reference band or line and choose the appropriate editing option to adjust its computation or thresholds.

For example, you can use defined ranges to indicate below-target, acceptable, and strong performance. Choose ranges that reflect the actual business requirements.

Step 9: Format the Chart

• Give the worksheet a descriptive title, such as Actual Sales vs Target by Region.
• Format the axis as currency if the values represent money.
• Use clear, contrasting marks for the actual value and target marker.
• Keep reference bands subtle so that they do not overpower the primary bar.
• Add useful tooltips containing the category, actual value, target, and performance difference.

Step 10: Validate the Results

Compare the bar and target marker with the original data. Confirm that the correct measures are being compared, that their aggregation is appropriate, and that the target uses the correct units and time period.

4. Creating a Bullet Chart Using Actual and Target Measures

In a business dataset, you may have fields such as Actual Sales and Target Sales. If these measures exist at the same level of detail, use them to compare performance.

Calculating Performance Difference

If your data contains Actual Sales and Target Sales, you can create a calculated field to show the difference.

// Calculated field: Sales Difference
SUM([Actual Sales]) - SUM([Target Sales])

A positive result means actual sales exceed the target, while a negative result means actual sales fall below the target. The calculation assumes both measures use compatible units, filters, and aggregation levels.

Calculating Target Achievement Percentage

// Calculated field: Target Achievement %
IF SUM([Target Sales]) != 0 THEN
    SUM([Actual Sales]) / SUM([Target Sales])
END

Format this calculated field as a percentage when displaying it in labels or tooltips. If the target is zero, the calculation returns no value for that case rather than dividing by zero.

5. Bullet Chart Interpretation and Best Practices

Interpreting Results

• Bar exceeds target: The primary measure has exceeded the comparison value.
• Bar falls short of target: The primary measure has not reached the target.
• Bar is near target: Performance is close to the benchmark, subject to the selected scale.
• Bar falls within a lower performance band: The result may require attention if the bands represent increasing performance levels.

Best Practices

• Use a clearly defined and meaningful target.
• Keep the scale consistent when comparing multiple categories.
• Use reference bands only when the ranges have a clear interpretation.
• Label the target and primary measure so users can distinguish them.
• Ensure actual and target values use compatible units and time periods.
• Do not rely only on color; include a legend, labels, or tooltips.
• Use a bullet chart when target comparison is important, rather than choosing it simply because it is visually compact.

6. Creating Treemaps in Tableau

6.1 What Is a Treemap?

A treemap is a visualization that represents data as a collection of nested or adjoining rectangles. Each rectangle represents a category or member, and its area corresponds to a quantitative measure.

Treemaps are particularly useful for displaying part-to-whole relationships. They can show how product categories, business units, regions, or departments contribute to a total.

6.2 Main Components of a Treemap

• Rectangle: Represents a category or member in the dataset.
• Size: Usually represents a measure such as Sales, Revenue, or Quantity.
• Color: Can represent a measure such as Profit or a dimension such as Category.
• Label: Identifies the category and may display a value.
• Hierarchy: Groups related categories, such as Category and Sub-Category.
• Tooltip: Provides detailed information when a user hovers over a rectangle.

6.3 When Should You Use a Treemap?

• Compare the sales contribution of different product categories.
• Analyze revenue generated by departments or business units.
• Identify which products account for the largest share of sales.
• Compare storage usage across folders or systems.
• Explore hierarchical data in a limited amount of screen space.
• Highlight the relationship between the size of a category and its profitability.

7. Step-by-Step: Create a Treemap

Step 1: Connect to a Dataset

Open Tableau and connect to a dataset such as Sample - Superstore. Confirm that the dataset contains at least one categorical dimension and a quantitative measure such as Sales.

Step 2: Open a New Worksheet

Create a new worksheet and review the available dimensions and measures in the Data pane.

Step 3: Select a Dimension

Drag Sub-Category to Columns or select it in the Data pane. A conventional bar chart may initially appear after you place a dimension and a measure on the shelves. This is normal; the next step changes the chart type.

Step 4: Add a Measure

Drag Sales to Rows. Tableau typically aggregates the measure as SUM(Sales), allowing you to compare total sales across the selected sub-categories.

Step 5: Open Show Me

Click Show Me and select Treemap. Tableau arranges the category members into rectangles whose areas are determined by the measure.

You can also build the view by selecting the appropriate dimensions and measure and then choosing Treemap from Show Me.

Step 6: Use Sales to Control Size

On the Marks card, ensure that Sales is assigned to Size. Larger rectangles represent higher values of the selected size measure, while smaller rectangles represent lower values.

Step 7: Add Profit to Color

Drag Profit to Color on the Marks card. The rectangle sizes continue to represent Sales, while the colors now represent Profit.

This view helps you identify categories with high sales and strong profitability, as well as categories that generate substantial sales but have low or negative profit.

Step 8: Add Labels

Drag Sub-Category and, if useful, Sales to Label. Labels can display category names and measure values. If the rectangles are too small, some labels may be difficult to read or may not fit.

Step 9: Customize Colors

Open Color and select Edit Colors to choose a suitable palette. Use a sequential palette when color represents a low-to-high measure. For Profit, a diverging palette can be useful when positive and negative values need to be distinguished.

Step 10: Format the Treemap

• Add a descriptive title such as Sales by Product Sub-Category and Profitability.
• Adjust mark size and labels for readability.
• Use subtle borders to distinguish adjacent rectangles.
• Configure tooltips to show category, sales, profit, and other relevant measures.
• Keep the color legend visible and make sure its meaning is clear.

8. Understanding Treemap Size and Color

Size and color are the most important visual encodings in a treemap. Assigning them deliberately helps users understand two related measures without creating a separate chart for each one.

Important: When a measure controls size, the area of the rectangle—not simply its width or height—communicates the value. Users should compare the rectangles as areas rather than judging them by one dimension alone.

9. Example: Product Sales Treemap

Business Scenario

A retail company wants to understand how different product sub-categories contribute to total sales and whether those sales are profitable.

In a treemap, Phones would have a larger rectangle than Fasteners because its sales are higher. If color represents Profit, Tables would be displayed using the color assigned to negative profit. This combination helps the analyst spot products that may deserve additional investigation.

Questions the Treemap Can Answer

• Which sub-categories contribute most to total sales?
• Which products have low sales contributions?
• Are any large sales contributors unprofitable?
• How are sales distributed across major categories?
• Which categories deserve further investigation?

10. Treemaps with Hierarchical Data

A hierarchy organizes dimensions from a broader group to a more detailed level. For example, Category can contain Sub-Category, and Sub-Category can contain individual products.

Example Hierarchy

All Products
├── Furniture
│   ├── Chairs
│   ├── Tables
│   └── Bookcases
├── Office Supplies
│   ├── Binders
│   ├── Paper
│   └── Storage
└── Technology
    ├── Phones
    ├── Machines
    └── Accessories

In Tableau, you can use multiple dimensions to divide the treemap into more detailed rectangles. For example, use Category and Sub-Category to represent a hierarchy, and use Sales to determine rectangle size.

Adding too many levels can produce many small rectangles that are difficult to interpret. Choose only the levels needed to answer the business question.

11. Bullet Chart vs. Treemap: Practical Comparison

12. Common Errors and Troubleshooting

13. Best Practices

For Bullet Charts

• Use a meaningful target or reference measure.
• Make the primary bar and target marker easy to distinguish.
• Use consistent scales when comparing categories.
• Use performance bands only when their thresholds are meaningful.
• Include actual and target values in tooltips.
• Validate that the measures use compatible units and periods.

For Treemaps

• Use size to represent a meaningful quantitative measure.
• Choose color based on a useful second measure or category.
• Keep category hierarchies manageable.
• Use labels selectively and rely on tooltips for additional detail.
• Use appropriate colors for positive and negative measures.
• Do not assume that a large rectangle represents high profit unless Profit is the measure controlling size.
• Consider a bar chart when precise ranking among similar values is more important than displaying part-to-whole relationships.

14. Adding Bullet Charts and Treemaps to a Dashboard

1. Create a bullet chart worksheet comparing actual performance with a target.
2. Create a treemap worksheet showing the contribution of categories or products.
3. Open a new dashboard.
4. Drag both worksheets onto the dashboard canvas.
5. Add a meaningful title, such as Sales Performance and Product Contribution Dashboard.
6. Add relevant filters, such as Region, Category, or Order Date.
7. Configure dashboard actions if selecting a treemap rectangle should filter the bullet chart or other related views.
8. Keep legends and labels readable and test the dashboard using different filters.

The bullet chart can answer whether performance meets a target, while the treemap can help identify which categories contribute most to the overall result.

15. Interview Questions and Answers

Q1. What is a bullet chart in Tableau?

Answer: A bullet chart compares a primary measure with a target or another reference measure. It may also contain shaded performance bands to provide context.

Q2. What is the main purpose of a bullet chart?

Answer: Its main purpose is to evaluate performance against a target, budget, benchmark, or goal in a compact format.

Q3. What are the main components of a bullet chart?

Answer: The main components are the primary bar, target or reference marker, performance bands, category dimension, and numerical axis.

Q4. Can a bullet chart compare actual sales and target sales?

Answer: Yes. Actual Sales can be represented by the primary bar and Target Sales by the reference marker or line.

Q5. What is a treemap in Tableau?

Answer: A treemap displays data as rectangles whose areas represent quantitative values. Color can represent another measure or a category.

Q6. Which shelves or Marks card properties are important when creating a treemap?

Answer: Size and Color on the Marks card are especially important. Dimensions can identify the rectangles, while a measure such as Sales determines their size.

Q7. Can a treemap display both Sales and Profit?

Answer: Yes. Sales can control rectangle size, while Profit controls color, enabling the user to compare sales contribution and profitability together.

Q8. What is the difference between a bullet chart and a treemap?

Answer: A bullet chart focuses on performance against a target. A treemap focuses on part-to-whole relationships and category contributions.

Q9. Why can treemap labels be difficult to read?

Answer: Small rectangles may not have enough space for text. Reducing labels, simplifying the hierarchy, and using tooltips can improve readability.

Q10. When should a bar chart be preferred over a treemap?

Answer: A bar chart is often preferable when users need to rank categories precisely or compare values with similar magnitudes. A treemap is useful when part-to-whole contribution and space-efficient category display are priorities.

16. Practical Exercises

Exercise 1: Actual Sales vs. Target Sales

• Use a dataset containing Region, Actual Sales, and Target Sales.
• Create a bullet chart with Region as the category.
• Check that Actual Sales is the primary measure and Target Sales is the comparison measure.
• Format the axis as currency.
• Identify which regions exceed their targets.

Exercise 2: Department Budget Analysis

• Use Department, Actual Expense, and Budget fields.
• Create a bullet chart comparing expenditure with the budget.
• Add meaningful performance bands if the organization has defined thresholds.
• Identify departments whose spending exceeds the budget.
• Write two observations based on the results.

Exercise 3: Product Sales Treemap

• Use Category, Sub-Category, Sales, and Profit.
• Create a treemap.
• Place Sales on Size and Profit on Color.
• Add Sub-Category to Label.
• Identify the largest sales contributors and any categories with negative profit.

Exercise 4: Combined Dashboard

• Create a bullet chart comparing actual sales with target sales by region.
• Create a treemap showing sales by product sub-category, colored by profit.
• Place both visualizations on a dashboard.
• Add a Region or Category filter where appropriate.
• Write a short report describing overall performance and the largest product contributors.

17. Quick Revision Checklist

• Understand the difference between bullet charts and treemaps.
• Know when to compare actual values against targets.
• Identify the primary measure, reference measure, and performance bands in a bullet chart.
• Know how to select Bullet Graph from Show Me.
• Understand how reference lines and bands provide context.
• Know how rectangle size and color work in a treemap.
• Use a quantitative measure such as Sales on Size.
• Use Color to represent a second measure or category.
• Format labels, legends, tooltips, and titles.
• Validate aggregations and compare results against the source data.
• Combine both charts in a dashboard when target performance and category contribution need to be analyzed together.

18. Conclusion

Bullet charts and treemaps are valuable Tableau visualizations for different analytical purposes. Bullet charts are designed to compare actual performance with targets or benchmarks, while treemaps show how categories contribute to a whole using rectangle size and color.

By selecting the right dimensions and measures, configuring reference values, choosing meaningful colors, and formatting labels and tooltips carefully, you can create visualizations that communicate business performance clearly. Combining these charts in a dashboard can help users understand both whether business goals are being met and which categories contribute most to the overall results.

Learn More: JustAcademy Tableau Training

Book a Demo: Register for a Tableau Course Demo

Official Documentation: Bullet Charts in Tableau | Treemaps in Tableau